Loading...

Change Number Format With Excel FIXED Function

19,554 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Jan 1, 2011

http://www.contextures.com/30excelfun... Use the FIXED function in Excel to round a number and return the result as text format (NOTE -- it only changes the number format, it does NOT change the numbers into words).

For instructions on changing written words to numbers (e.g. from Three to 3), see Words to Numbers in Excel: http://blog.contextures.com/archives/...

The FIXED function can round a number to a set number of decimal places, and show the result as text, with or without comma separators.

In most cases, another function, such as ROUND or TEXT, or simply changing the cell's number format, would be a better choice.

Watch this video to see how to use the Excel FIXED function, and return a rounded number as text.

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...