LinkBack URL
About LinkBacks
Input $1,000,000 but the cell shows $100,000, have tried to reformat, nothing worked. How to resolve this issue. This problem exsit in every excel file. Your prompt help is appreciated.
Input $1,000,000 but the cell shows $100,000, have tried to reformat, nothing worked. How to resolve this issue. This problem exsit in every excel file. Your prompt help is appreciated.
Last edited by VBA Noob; 03-13-2007 at 04:11 PM.
If you tried reformatting and that didn't work. Open another new workbook put $1,000,000 in a cell, so that it is the correct format, click on the Paintbrush icon and then "slap it" all over the cell in the other workbook.
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Tools > Options > Edit > untick "fixed decimal places"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks