Number Format

  • Thread starter Thread starter Nikki
  • Start date Start date
N

Nikki

Does anyone know how I could automatically format a number to change from
1,776,176 to 1,776? I can insert a round number but it doesn't drop the 000's.

Thanks
 
Use custom format 0,; to show thousands
Or 0,,; to show millions

Remember that this will NOT alter the stored value, only the display
best wishes
 
Hi,
Use this
=ROUND(A1/1000,0)
change the cell reference as it suits you
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering for numbers ending in 000 3
Access Making a memo in Access 0
Format a number in a scecial way 8
E+14 error 2
Converting Phone Numbers 4
Excel Sequential Numbering System 0
Find cell containing a letter 5
custom inputs 1

Back
Top