•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel adds zeros to numbers?
Our take
It sounds like you're encountering an unexpected issue with your Excel program where inputting a number results in it being converted to a larger value, such as 2 becoming 2000. This could be due to formatting settings or data input errors within the spreadsheet. Don’t worry—many users face similar challenges. In this guide, we’ll explore common reasons for this problem and provide clear solutions to help you regain control over your data entry, ensuring a smoother experience with Excel.
Help with excel adding zeroes
I’ll preface this by saying I’m not fluent in excel at all.
One of our premade excel programs all of a sudden is giving me fits. Anytime I try to put in a number it makes it a thousand. Doesn’t matter where I try to type a number it always adds 3 zeroes to the end after I hit enter or an arrow key to move to another cell.
For example: i input the number 2 and hit enter, it changes the 2 to 2000.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Need to be able to use dashes or 0s in cells; getting error from excelI have a spreadsheet I'm working on where I need to be able to enter 0% as a value sometimes, and other times I need to be able to enter a dash as a way to indicated n/a. I can't figure out how to even enter a dash without getting a "don't leave cell empty, enter a 0" warning from excel. Is there a way to format this that will let me do either? I've tried playing with conditional formatting and custom cell formats but can't figure it out. Also does anyone know where that "don't leave this cell empty" error might be coming from? It will let me do zeroes and dashes in other cells, but this spreadsheet was given to me pre-made and I think they must have changed some setting on these cells that I don't know how to undo. Tried googling and got frustrated. submitted by /u/conditional_identity [link] [comments]
- Need macro advice! Saving longer numbers as strings to show all the charactersDesktop, Excel 365 Build 19929.20106 Click-to-Run, Beginner We have a macro that generates new files using a list of data. Sometimes that data is completely numerical with over 15 digits. Excel keeps reformatting these numerical entries using scientific notation, which screws up the output files. Right now I have to manually check the output files and reformat the affected ones so that all then hidden characters are shown. Can someone please advise on how I can update the macro to automatically convert these numbers into strings that show all the characters? The data is of variable length, but I'm pretty sure it's always under 20 characters. This problem only affects one cell of the output file. Everything else is generated without issue. It's basically the problem of "how do I make Excel macro copy-paste the entire FedEx tracking number correctly" but the data isn't consistently 16 characters and is frequently alphanumeric. EDIT: I'm open to even stupid and booleg solutions like "add a hidden text character before transferring the data" to force this to work. The output files are basically just printables. I just don't know anything about macros and do not have time to learn. submitted by /u/Umklopp [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#natural language processing for spreadsheets#generative AI for data analysis#financial modeling with spreadsheets#Excel#numbers#zeroes#thousand#premade programs#input#cell#hit enter#3 zeroes#change#arrow key#fluent#giving fits