Format 1,234.56 instead 1.234,56

		Microsoft Office Forums > Microsoft Excel > Excel
Format 1,234.56 instead 1.234,56

12-14-2015, 10:05 PM

sdrawkcab

Windows 7 32bit Format 1,234.56 instead 1.234,56

Office 2003

Novice

Join Date: Dec 2015

Posts: 4

A1 is misformatted number as per example.

B1 =VALUE(SUBSTITUTE(SUBSTITUTE(A1,".",","),",",".",2 ))

Format B1 as number and select 1000's seperator

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
format 00:00:00: AM and not 00:00	habiler	Word	3	03-05-2015 12:56 PM
Format Painter doesn't work on Table Format?	Joey Cheung	Word Tables	1	08-20-2014 02:24 AM
1.image in a table 2.right click 3.menu click format 4.a format column appears	OldFatDog	Drawing and Graphics	1	06-13-2014 11:19 PM
Change from General Format to number format	gbaker	Excel	3	08-16-2013 01:04 PM
Format a Row	Eagle710	Excel	0	08-05-2009 08:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:32 PM.